package com.theanh.RssActivity.db;

public class ChannelTable {
	public static final String SQL_CREATE =
		"create table IF NOT EXISTS Channel (ChannelID integer primary key autoincrement, "
		+ "Name text not null, Url text not null, LogoUrl text, CategoryID integer not null, "
		+ DbAdapter.constraintFK("FK_CategoryChannel", ChannelTable.CATEGORY_ID, CategoryTable.TABLE_NAME, CategoryTable.ID)
		+ ");";
	
	public static final String TABLE_NAME = "Channel";
	
	public static final String ID = "ChannelID";
	public static final String NAME = "Name";
	public static final String URL = "Url";
	public static final String LOGO_URL = "LogoUrl";
	public static final String CATEGORY_ID = "CategoryID";
	
	public static final String[] CULUMNS = new String[]{ ID, NAME, URL, LOGO_URL, CATEGORY_ID};
	
}
